﻿using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Web;

namespace BaoShouTangServer.Models
{

    public partial class recordoutsq
    {
        public recordoutsq()
        { }
        #region Model
        private long _autoid;
        private long _id;
        private string _cinvcode;
        private string _cinvaddcode;
        private string _cinvname;
        private string _cinvstd;
        private string _cinvccode;
        private string _cinvm_unit;
        private string _cinva_unit;
        private string _creplaceitem;
        private string _cposition;
        private string _cinvdefine1;
        private string _cinvdefine2;
        private string _cinvdefine3;
        private string _cinvdefine4;
        private string _cinvdefine5;
        private string _cinvdefine6;
        private string _cinvdefine7;
        private string _cinvdefine8;
        private string _cinvdefine9;
        private string _cinvdefine10;
        private int? _cinvdefine11;
        private int? _cinvdefine12;
        private decimal? _cinvdefine13;
        private decimal? _cinvdefine14;
        private DateTime? _cinvdefine15;
        private DateTime? _cinvdefine16;
        private int? _iid;
        private string _cfree1;
        private string _cfree2;
        private string _cfree3;
        private string _cfree4;
        private string _cfree5;
        private string _cfree6;
        private string _cfree7;
        private string _cfree8;
        private string _cfree9;
        private string _cfree10;
        private string _cbatch;
        private decimal? _iinvexchrate;
        private decimal? _inum;
        private decimal? _iquantity;
        private decimal? _iunitcost;
        private decimal? _iprice;
        private string _cbarcode;
        private decimal? _ipunitcost;
        private decimal? _ipprice;
        private DateTime? _dvdate;
        private string _cobjcode;
        private decimal? _isoutquantity;
        private decimal? _isoutnum;
        private decimal? _inquantity;
        private decimal? _innum;
        private string _cassunit;
        private DateTime? _dmadedate;
        private decimal? _ifquantity;
        private decimal? _ifnum;
        private long _cvouchcode;
        private string _cdefine22;
        private string _cdefine23;
        private string _cdefine24;
        private string _cdefine25;
        private decimal? _cdefine26;
        private decimal? _cdefine27;
        private string _cdefine28;
        private string _cdefine29;
        private string _cdefine30;
        private string _cdefine31;
        private string _cdefine32;
        private string _cdefine33;
        private int? _cdefine34;
        private int? _cdefine35;
        private DateTime? _cdefine36;
        private DateTime? _cdefine37;
        private long _impoids;
        private long _icheckids;
        private string _citemcode;
        private string _citem_class;
        private string _cname;
        private string _citemcname;
        private string _cbvencode;
        private string _cvenname;
        private int? _imassdate;
        private string _cinvouchcode;
        private decimal? _imaterialfee;
        private long _iomomid;
        private int? _iomodid;
        private string _comcode;
        private string _cmassunit;
        private string _cposname;
        private decimal? _isquantity;
        private decimal? _ismaterialfee;
        private DateTime? _dmsdate;
        private string _cmocode;
        private int? _imoseq;
        private string _cmolotcode;
        private string _iopseq;
        private string _copdesc;
        private string _cmworkcentercode;
        private string _cmworkcenter;
        private string _invcode;
        private string _invname;
        private string _invstd;
        private string _corufts;
        private string _isodid;
        private int _isotype;
        private string _csocode;
        private int? _isoseq;
        private string _cdemandmemo;
        private int? _iordertype;
        private int? _iorderdid;
        private string _iordercode;
        private int? _iorderseq;
        private string _cbaccounter;
        private bool _bcosting;
        private DateTime? _dbkeepdate;
        private string _cvmivencode;
        private string _cvmivenname;
        private bool _bvmiused;
        private decimal? _ivmisettlequantity;
        private decimal? _ivmisettlenum;
        private long _imaids;
        private int? _iinvsncount;
        private decimal? _iuninvsncount;
        private string _cwhpersoncode;
        private string _cwhpersonname;
        private string _crejectcode;
        private int? _iexpiratdatecalcu;
        private string _cexpirationdate;
        private DateTime? _dexpirationdate;
        private string _cciqbookcode;
        private decimal? _ibondedsumqty;
        private int? _productinids;
        private decimal? _cbatchproperty1;
        private decimal? _cbatchproperty2;
        private decimal? _cbatchproperty3;
        private decimal? _cbatchproperty4;
        private decimal? _cbatchproperty5;
        private string _cbatchproperty6;
        private string _cbatchproperty7;
        private string _cbatchproperty8;
        private string _cbatchproperty9;
        private DateTime? _cbatchproperty10;
        private int? _irsrowno;
        private string _cbmemo;
        private string _cbinvsn;
        private int? _applydid;
        private string _applycode;
        private int? _irowno;
        private Guid _strowguid;
        private int? _vmiveniid;
        private string _cservicecode;
        private int? _bveniid;
        private string _cinvouchtype;
        private long _coutvouchid;
        private string _coutvouchtype;
        private decimal? _isredoutquantity;
        private decimal? _isredoutnum;
        private long _itrids;
        private string _ipesodid;
        private int? _ipesotype;
        private string _cpesocode;
        private int? _ipesoseq;
        private int? _bsupersede;
        private decimal? _isupersedeqty;
        private int? _isupersedempoids;
        private Guid _imoallocatesubid;
        private string _cinvouchercode;
        private int? _cinvoucherlineid;
        private string _cinvouchertype;
        private string _cbsysbarcode;
        private string _csourcemocode;
        private int? _isourcemodetailsid;
        private string _cplanlotcode;
        private int _bcanreplace;
        private int? _iposflag;
        private int _boutmaterials;
        private decimal? _iavaquantity;
        private decimal? _iavanum;
        private decimal? _ipresent;
        private decimal? _ipresentnum;
        /// <summary>
        /// 
        /// </summary>
        public long autoid
        {
            set { _autoid = value; }
            get { return _autoid; }
        }
        /// <summary>
        /// 
        /// </summary>
        public long id
        {
            set { _id = value; }
            get { return _id; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cinvcode
        {
            set { _cinvcode = value; }
            get { return _cinvcode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cinvaddcode
        {
            set { _cinvaddcode = value; }
            get { return _cinvaddcode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cinvname
        {
            set { _cinvname = value; }
            get { return _cinvname; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cinvstd
        {
            set { _cinvstd = value; }
            get { return _cinvstd; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cinvccode
        {
            set { _cinvccode = value; }
            get { return _cinvccode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cinvm_unit
        {
            set { _cinvm_unit = value; }
            get { return _cinvm_unit; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cinva_unit
        {
            set { _cinva_unit = value; }
            get { return _cinva_unit; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string creplaceitem
        {
            set { _creplaceitem = value; }
            get { return _creplaceitem; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cposition
        {
            set { _cposition = value; }
            get { return _cposition; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cinvdefine1
        {
            set { _cinvdefine1 = value; }
            get { return _cinvdefine1; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cinvdefine2
        {
            set { _cinvdefine2 = value; }
            get { return _cinvdefine2; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cinvdefine3
        {
            set { _cinvdefine3 = value; }
            get { return _cinvdefine3; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cinvdefine4
        {
            set { _cinvdefine4 = value; }
            get { return _cinvdefine4; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cinvdefine5
        {
            set { _cinvdefine5 = value; }
            get { return _cinvdefine5; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cinvdefine6
        {
            set { _cinvdefine6 = value; }
            get { return _cinvdefine6; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cinvdefine7
        {
            set { _cinvdefine7 = value; }
            get { return _cinvdefine7; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cinvdefine8
        {
            set { _cinvdefine8 = value; }
            get { return _cinvdefine8; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cinvdefine9
        {
            set { _cinvdefine9 = value; }
            get { return _cinvdefine9; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cinvdefine10
        {
            set { _cinvdefine10 = value; }
            get { return _cinvdefine10; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? cinvdefine11
        {
            set { _cinvdefine11 = value; }
            get { return _cinvdefine11; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? cinvdefine12
        {
            set { _cinvdefine12 = value; }
            get { return _cinvdefine12; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? cinvdefine13
        {
            set { _cinvdefine13 = value; }
            get { return _cinvdefine13; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? cinvdefine14
        {
            set { _cinvdefine14 = value; }
            get { return _cinvdefine14; }
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime? cinvdefine15
        {
            set { _cinvdefine15 = value; }
            get { return _cinvdefine15; }
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime? cinvdefine16
        {
            set { _cinvdefine16 = value; }
            get { return _cinvdefine16; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? iid
        {
            set { _iid = value; }
            get { return _iid; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cfree1
        {
            set { _cfree1 = value; }
            get { return _cfree1; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cfree2
        {
            set { _cfree2 = value; }
            get { return _cfree2; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cfree3
        {
            set { _cfree3 = value; }
            get { return _cfree3; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cfree4
        {
            set { _cfree4 = value; }
            get { return _cfree4; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cfree5
        {
            set { _cfree5 = value; }
            get { return _cfree5; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cfree6
        {
            set { _cfree6 = value; }
            get { return _cfree6; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cfree7
        {
            set { _cfree7 = value; }
            get { return _cfree7; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cfree8
        {
            set { _cfree8 = value; }
            get { return _cfree8; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cfree9
        {
            set { _cfree9 = value; }
            get { return _cfree9; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cfree10
        {
            set { _cfree10 = value; }
            get { return _cfree10; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cbatch
        {
            set { _cbatch = value; }
            get { return _cbatch; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? iinvexchrate
        {
            set { _iinvexchrate = value; }
            get { return _iinvexchrate; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? inum
        {
            set { _inum = value; }
            get { return _inum; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? iquantity
        {
            set { _iquantity = value; }
            get { return _iquantity; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? iunitcost
        {
            set { _iunitcost = value; }
            get { return _iunitcost; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? iprice
        {
            set { _iprice = value; }
            get { return _iprice; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cbarcode
        {
            set { _cbarcode = value; }
            get { return _cbarcode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? ipunitcost
        {
            set { _ipunitcost = value; }
            get { return _ipunitcost; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? ipprice
        {
            set { _ipprice = value; }
            get { return _ipprice; }
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime? dvdate
        {
            set { _dvdate = value; }
            get { return _dvdate; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cobjcode
        {
            set { _cobjcode = value; }
            get { return _cobjcode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? isoutquantity
        {
            set { _isoutquantity = value; }
            get { return _isoutquantity; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? isoutnum
        {
            set { _isoutnum = value; }
            get { return _isoutnum; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? inquantity
        {
            set { _inquantity = value; }
            get { return _inquantity; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? innum
        {
            set { _innum = value; }
            get { return _innum; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cassunit
        {
            set { _cassunit = value; }
            get { return _cassunit; }
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime? dmadedate
        {
            set { _dmadedate = value; }
            get { return _dmadedate; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? ifquantity
        {
            set { _ifquantity = value; }
            get { return _ifquantity; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? ifnum
        {
            set { _ifnum = value; }
            get { return _ifnum; }
        }
        /// <summary>
        /// 
        /// </summary>
        public long cvouchcode
        {
            set { _cvouchcode = value; }
            get { return _cvouchcode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cdefine22
        {
            set { _cdefine22 = value; }
            get { return _cdefine22; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cdefine23
        {
            set { _cdefine23 = value; }
            get { return _cdefine23; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cdefine24
        {
            set { _cdefine24 = value; }
            get { return _cdefine24; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cdefine25
        {
            set { _cdefine25 = value; }
            get { return _cdefine25; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? cdefine26
        {
            set { _cdefine26 = value; }
            get { return _cdefine26; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? cdefine27
        {
            set { _cdefine27 = value; }
            get { return _cdefine27; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cdefine28
        {
            set { _cdefine28 = value; }
            get { return _cdefine28; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cdefine29
        {
            set { _cdefine29 = value; }
            get { return _cdefine29; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cdefine30
        {
            set { _cdefine30 = value; }
            get { return _cdefine30; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cdefine31
        {
            set { _cdefine31 = value; }
            get { return _cdefine31; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cdefine32
        {
            set { _cdefine32 = value; }
            get { return _cdefine32; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cdefine33
        {
            set { _cdefine33 = value; }
            get { return _cdefine33; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? cdefine34
        {
            set { _cdefine34 = value; }
            get { return _cdefine34; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? cdefine35
        {
            set { _cdefine35 = value; }
            get { return _cdefine35; }
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime? cdefine36
        {
            set { _cdefine36 = value; }
            get { return _cdefine36; }
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime? cdefine37
        {
            set { _cdefine37 = value; }
            get { return _cdefine37; }
        }
        /// <summary>
        /// 
        /// </summary>
        public long impoids
        {
            set { _impoids = value; }
            get { return _impoids; }
        }
        /// <summary>
        /// 
        /// </summary>
        public long icheckids
        {
            set { _icheckids = value; }
            get { return _icheckids; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string citemcode
        {
            set { _citemcode = value; }
            get { return _citemcode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string citem_class
        {
            set { _citem_class = value; }
            get { return _citem_class; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cname
        {
            set { _cname = value; }
            get { return _cname; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string citemcname
        {
            set { _citemcname = value; }
            get { return _citemcname; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cbvencode
        {
            set { _cbvencode = value; }
            get { return _cbvencode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cvenname
        {
            set { _cvenname = value; }
            get { return _cvenname; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? imassdate
        {
            set { _imassdate = value; }
            get { return _imassdate; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cinvouchcode
        {
            set { _cinvouchcode = value; }
            get { return _cinvouchcode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? imaterialfee
        {
            set { _imaterialfee = value; }
            get { return _imaterialfee; }
        }
        /// <summary>
        /// 
        /// </summary>
        public long iomomid
        {
            set { _iomomid = value; }
            get { return _iomomid; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? iomodid
        {
            set { _iomodid = value; }
            get { return _iomodid; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string comcode
        {
            set { _comcode = value; }
            get { return _comcode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cmassunit
        {
            set { _cmassunit = value; }
            get { return _cmassunit; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cposname
        {
            set { _cposname = value; }
            get { return _cposname; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? isquantity
        {
            set { _isquantity = value; }
            get { return _isquantity; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? ismaterialfee
        {
            set { _ismaterialfee = value; }
            get { return _ismaterialfee; }
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime? dmsdate
        {
            set { _dmsdate = value; }
            get { return _dmsdate; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cmocode
        {
            set { _cmocode = value; }
            get { return _cmocode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? imoseq
        {
            set { _imoseq = value; }
            get { return _imoseq; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cmolotcode
        {
            set { _cmolotcode = value; }
            get { return _cmolotcode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string iopseq
        {
            set { _iopseq = value; }
            get { return _iopseq; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string copdesc
        {
            set { _copdesc = value; }
            get { return _copdesc; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cmworkcentercode
        {
            set { _cmworkcentercode = value; }
            get { return _cmworkcentercode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cmworkcenter
        {
            set { _cmworkcenter = value; }
            get { return _cmworkcenter; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string invcode
        {
            set { _invcode = value; }
            get { return _invcode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string invname
        {
            set { _invname = value; }
            get { return _invname; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string invstd
        {
            set { _invstd = value; }
            get { return _invstd; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string corufts
        {
            set { _corufts = value; }
            get { return _corufts; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string isodid
        {
            set { _isodid = value; }
            get { return _isodid; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int isotype
        {
            set { _isotype = value; }
            get { return _isotype; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string csocode
        {
            set { _csocode = value; }
            get { return _csocode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? isoseq
        {
            set { _isoseq = value; }
            get { return _isoseq; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cdemandmemo
        {
            set { _cdemandmemo = value; }
            get { return _cdemandmemo; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? iordertype
        {
            set { _iordertype = value; }
            get { return _iordertype; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? iorderdid
        {
            set { _iorderdid = value; }
            get { return _iorderdid; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string iordercode
        {
            set { _iordercode = value; }
            get { return _iordercode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? iorderseq
        {
            set { _iorderseq = value; }
            get { return _iorderseq; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cbaccounter
        {
            set { _cbaccounter = value; }
            get { return _cbaccounter; }
        }
        /// <summary>
        /// 
        /// </summary>
        public bool bcosting
        {
            set { _bcosting = value; }
            get { return _bcosting; }
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime? dbkeepdate
        {
            set { _dbkeepdate = value; }
            get { return _dbkeepdate; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cvmivencode
        {
            set { _cvmivencode = value; }
            get { return _cvmivencode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cvmivenname
        {
            set { _cvmivenname = value; }
            get { return _cvmivenname; }
        }
        /// <summary>
        /// 
        /// </summary>
        public bool bvmiused
        {
            set { _bvmiused = value; }
            get { return _bvmiused; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? ivmisettlequantity
        {
            set { _ivmisettlequantity = value; }
            get { return _ivmisettlequantity; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? ivmisettlenum
        {
            set { _ivmisettlenum = value; }
            get { return _ivmisettlenum; }
        }
        /// <summary>
        /// 
        /// </summary>
        public long imaids
        {
            set { _imaids = value; }
            get { return _imaids; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? iinvsncount
        {
            set { _iinvsncount = value; }
            get { return _iinvsncount; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? iuninvsncount
        {
            set { _iuninvsncount = value; }
            get { return _iuninvsncount; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cwhpersoncode
        {
            set { _cwhpersoncode = value; }
            get { return _cwhpersoncode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cwhpersonname
        {
            set { _cwhpersonname = value; }
            get { return _cwhpersonname; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string crejectcode
        {
            set { _crejectcode = value; }
            get { return _crejectcode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? iexpiratdatecalcu
        {
            set { _iexpiratdatecalcu = value; }
            get { return _iexpiratdatecalcu; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cexpirationdate
        {
            set { _cexpirationdate = value; }
            get { return _cexpirationdate; }
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime? dexpirationdate
        {
            set { _dexpirationdate = value; }
            get { return _dexpirationdate; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cciqbookcode
        {
            set { _cciqbookcode = value; }
            get { return _cciqbookcode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? ibondedsumqty
        {
            set { _ibondedsumqty = value; }
            get { return _ibondedsumqty; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? productinids
        {
            set { _productinids = value; }
            get { return _productinids; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? cbatchproperty1
        {
            set { _cbatchproperty1 = value; }
            get { return _cbatchproperty1; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? cbatchproperty2
        {
            set { _cbatchproperty2 = value; }
            get { return _cbatchproperty2; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? cbatchproperty3
        {
            set { _cbatchproperty3 = value; }
            get { return _cbatchproperty3; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? cbatchproperty4
        {
            set { _cbatchproperty4 = value; }
            get { return _cbatchproperty4; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? cbatchproperty5
        {
            set { _cbatchproperty5 = value; }
            get { return _cbatchproperty5; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cbatchproperty6
        {
            set { _cbatchproperty6 = value; }
            get { return _cbatchproperty6; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cbatchproperty7
        {
            set { _cbatchproperty7 = value; }
            get { return _cbatchproperty7; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cbatchproperty8
        {
            set { _cbatchproperty8 = value; }
            get { return _cbatchproperty8; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cbatchproperty9
        {
            set { _cbatchproperty9 = value; }
            get { return _cbatchproperty9; }
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime? cbatchproperty10
        {
            set { _cbatchproperty10 = value; }
            get { return _cbatchproperty10; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? irsrowno
        {
            set { _irsrowno = value; }
            get { return _irsrowno; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cbmemo
        {
            set { _cbmemo = value; }
            get { return _cbmemo; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cbinvsn
        {
            set { _cbinvsn = value; }
            get { return _cbinvsn; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? applydid
        {
            set { _applydid = value; }
            get { return _applydid; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string applycode
        {
            set { _applycode = value; }
            get { return _applycode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? irowno
        {
            set { _irowno = value; }
            get { return _irowno; }
        }
        /// <summary>
        /// 
        /// </summary>
        public Guid strowguid
        {
            set { _strowguid = value; }
            get { return _strowguid; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? vmiveniid
        {
            set { _vmiveniid = value; }
            get { return _vmiveniid; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cservicecode
        {
            set { _cservicecode = value; }
            get { return _cservicecode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? bveniid
        {
            set { _bveniid = value; }
            get { return _bveniid; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cinvouchtype
        {
            set { _cinvouchtype = value; }
            get { return _cinvouchtype; }
        }
        /// <summary>
        /// 
        /// </summary>
        public long coutvouchid
        {
            set { _coutvouchid = value; }
            get { return _coutvouchid; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string coutvouchtype
        {
            set { _coutvouchtype = value; }
            get { return _coutvouchtype; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? isredoutquantity
        {
            set { _isredoutquantity = value; }
            get { return _isredoutquantity; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? isredoutnum
        {
            set { _isredoutnum = value; }
            get { return _isredoutnum; }
        }
        /// <summary>
        /// 
        /// </summary>
        public long itrids
        {
            set { _itrids = value; }
            get { return _itrids; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string ipesodid
        {
            set { _ipesodid = value; }
            get { return _ipesodid; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? ipesotype
        {
            set { _ipesotype = value; }
            get { return _ipesotype; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cpesocode
        {
            set { _cpesocode = value; }
            get { return _cpesocode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? ipesoseq
        {
            set { _ipesoseq = value; }
            get { return _ipesoseq; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? bsupersede
        {
            set { _bsupersede = value; }
            get { return _bsupersede; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? isupersedeqty
        {
            set { _isupersedeqty = value; }
            get { return _isupersedeqty; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? isupersedempoids
        {
            set { _isupersedempoids = value; }
            get { return _isupersedempoids; }
        }
        /// <summary>
        /// 
        /// </summary>
        public Guid imoallocatesubid
        {
            set { _imoallocatesubid = value; }
            get { return _imoallocatesubid; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cinvouchercode
        {
            set { _cinvouchercode = value; }
            get { return _cinvouchercode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? cinvoucherlineid
        {
            set { _cinvoucherlineid = value; }
            get { return _cinvoucherlineid; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cinvouchertype
        {
            set { _cinvouchertype = value; }
            get { return _cinvouchertype; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cbsysbarcode
        {
            set { _cbsysbarcode = value; }
            get { return _cbsysbarcode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string csourcemocode
        {
            set { _csourcemocode = value; }
            get { return _csourcemocode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? isourcemodetailsid
        {
            set { _isourcemodetailsid = value; }
            get { return _isourcemodetailsid; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cplanlotcode
        {
            set { _cplanlotcode = value; }
            get { return _cplanlotcode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int bcanreplace
        {
            set { _bcanreplace = value; }
            get { return _bcanreplace; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? iposflag
        {
            set { _iposflag = value; }
            get { return _iposflag; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int boutmaterials
        {
            set { _boutmaterials = value; }
            get { return _boutmaterials; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? iavaquantity
        {
            set { _iavaquantity = value; }
            get { return _iavaquantity; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? iavanum
        {
            set { _iavanum = value; }
            get { return _iavanum; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? ipresent
        {
            set { _ipresent = value; }
            get { return _ipresent; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? ipresentnum
        {
            set { _ipresentnum = value; }
            get { return _ipresentnum; }
        }
        #endregion Model


        #region  Method

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(string tablename)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into " + tablename + " (");
            strSql.Append("autoid,id,cinvcode,cinvaddcode,cinvname,cinvstd,cinvccode,cinvm_unit,cinva_unit,creplaceitem,cposition,cinvdefine1,cinvdefine2,cinvdefine3,cinvdefine4,cinvdefine5,cinvdefine6,cinvdefine7,cinvdefine8,cinvdefine9,cinvdefine10,cinvdefine11,cinvdefine12,cinvdefine13,cinvdefine14,cinvdefine15,cinvdefine16,iid,cfree1,cfree2,cfree3,cfree4,cfree5,cfree6,cfree7,cfree8,cfree9,cfree10,cbatch,iinvexchrate,inum,iquantity,iunitcost,iprice,cbarcode,ipunitcost,ipprice,dvdate,cobjcode,isoutquantity,isoutnum,inquantity,innum,cassunit,dmadedate,ifquantity,ifnum,cvouchcode,cdefine22,cdefine23,cdefine24,cdefine25,cdefine26,cdefine27,cdefine28,cdefine29,cdefine30,cdefine31,cdefine32,cdefine33,cdefine34,cdefine35,cdefine36,cdefine37,impoids,icheckids,citemcode,citem_class,cname,citemcname,cbvencode,cvenname,imassdate,cinvouchcode,imaterialfee,iomomid,iomodid,comcode,cmassunit,cposname,isquantity,ismaterialfee,dmsdate,cmocode,imoseq,cmolotcode,iopseq,copdesc,cmworkcentercode,cmworkcenter,invcode,invname,invstd,corufts,isodid,isotype,csocode,isoseq,cdemandmemo,iordertype,iorderdid,iordercode,iorderseq,cbaccounter,bcosting,dbkeepdate,cvmivencode,cvmivenname,bvmiused,ivmisettlequantity,ivmisettlenum,imaids,iinvsncount,iuninvsncount,cwhpersoncode,cwhpersonname,crejectcode,iexpiratdatecalcu,cexpirationdate,dexpirationdate,cciqbookcode,ibondedsumqty,productinids,cbatchproperty1,cbatchproperty2,cbatchproperty3,cbatchproperty4,cbatchproperty5,cbatchproperty6,cbatchproperty7,cbatchproperty8,cbatchproperty9,cbatchproperty10,irsrowno,cbmemo,cbinvsn,applydid,applycode,irowno,strowguid,vmiveniid,cservicecode,bveniid,cinvouchtype,coutvouchid,coutvouchtype,isredoutquantity,isredoutnum,itrids,ipesodid,ipesotype,cpesocode,ipesoseq,bsupersede,isupersedeqty,isupersedempoids,imoallocatesubid,cinvouchercode,cinvoucherlineid,cinvouchertype,cbsysbarcode,csourcemocode,isourcemodetailsid,cplanlotcode,bcanreplace,iposflag,boutmaterials,iavaquantity,iavanum,ipresent,ipresentnum)");
            strSql.Append(" values (");
            strSql.Append("@autoid,@id,@cinvcode,@cinvaddcode,@cinvname,@cinvstd,@cinvccode,@cinvm_unit,@cinva_unit,@creplaceitem,@cposition,@cinvdefine1,@cinvdefine2,@cinvdefine3,@cinvdefine4,@cinvdefine5,@cinvdefine6,@cinvdefine7,@cinvdefine8,@cinvdefine9,@cinvdefine10,@cinvdefine11,@cinvdefine12,@cinvdefine13,@cinvdefine14,@cinvdefine15,@cinvdefine16,@iid,@cfree1,@cfree2,@cfree3,@cfree4,@cfree5,@cfree6,@cfree7,@cfree8,@cfree9,@cfree10,@cbatch,@iinvexchrate,@inum,@iquantity,@iunitcost,@iprice,@cbarcode,@ipunitcost,@ipprice,@dvdate,@cobjcode,@isoutquantity,@isoutnum,@inquantity,@innum,@cassunit,@dmadedate,@ifquantity,@ifnum,@cvouchcode,@cdefine22,@cdefine23,@cdefine24,@cdefine25,@cdefine26,@cdefine27,@cdefine28,@cdefine29,@cdefine30,@cdefine31,@cdefine32,@cdefine33,@cdefine34,@cdefine35,@cdefine36,@cdefine37,@impoids,@icheckids,@citemcode,@citem_class,@cname,@citemcname,@cbvencode,@cvenname,@imassdate,@cinvouchcode,@imaterialfee,@iomomid,@iomodid,@comcode,@cmassunit,@cposname,@isquantity,@ismaterialfee,@dmsdate,@cmocode,@imoseq,@cmolotcode,@iopseq,@copdesc,@cmworkcentercode,@cmworkcenter,@invcode,@invname,@invstd,@corufts,@isodid,@isotype,@csocode,@isoseq,@cdemandmemo,@iordertype,@iorderdid,@iordercode,@iorderseq,@cbaccounter,@bcosting,@dbkeepdate,@cvmivencode,@cvmivenname,@bvmiused,@ivmisettlequantity,@ivmisettlenum,@imaids,@iinvsncount,@iuninvsncount,@cwhpersoncode,@cwhpersonname,@crejectcode,@iexpiratdatecalcu,@cexpirationdate,@dexpirationdate,@cciqbookcode,@ibondedsumqty,@productinids,@cbatchproperty1,@cbatchproperty2,@cbatchproperty3,@cbatchproperty4,@cbatchproperty5,@cbatchproperty6,@cbatchproperty7,@cbatchproperty8,@cbatchproperty9,@cbatchproperty10,@irsrowno,@cbmemo,@cbinvsn,@applydid,@applycode,@irowno,@strowguid,@vmiveniid,@cservicecode,@bveniid,@cinvouchtype,@coutvouchid,@coutvouchtype,@isredoutquantity,@isredoutnum,@itrids,@ipesodid,@ipesotype,@cpesocode,@ipesoseq,@bsupersede,@isupersedeqty,@isupersedempoids,@imoallocatesubid,@cinvouchercode,@cinvoucherlineid,@cinvouchertype,@cbsysbarcode,@csourcemocode,@isourcemodetailsid,@cplanlotcode,@bcanreplace,@iposflag,@boutmaterials,@iavaquantity,@iavanum,@ipresent,@ipresentnum)");
            SqlParameter[] parameters = {
                    new SqlParameter("@autoid", SqlDbType.BigInt,8),
                    new SqlParameter("@id", SqlDbType.BigInt,8),
                    new SqlParameter("@cinvcode", SqlDbType.NVarChar,60),
                    new SqlParameter("@cinvaddcode", SqlDbType.NVarChar,255),
                    new SqlParameter("@cinvname", SqlDbType.NVarChar,255),
                    new SqlParameter("@cinvstd", SqlDbType.NVarChar,255),
                    new SqlParameter("@cinvccode", SqlDbType.NVarChar,12),
                    new SqlParameter("@cinvm_unit", SqlDbType.NVarChar,20),
                    new SqlParameter("@cinva_unit", SqlDbType.NVarChar,20),
                    new SqlParameter("@creplaceitem", SqlDbType.NVarChar,60),
                    new SqlParameter("@cposition", SqlDbType.NVarChar,20),
                    new SqlParameter("@cinvdefine1", SqlDbType.NVarChar,20),
                    new SqlParameter("@cinvdefine2", SqlDbType.NVarChar,20),
                    new SqlParameter("@cinvdefine3", SqlDbType.NVarChar,20),
                    new SqlParameter("@cinvdefine4", SqlDbType.NVarChar,60),
                    new SqlParameter("@cinvdefine5", SqlDbType.NVarChar,60),
                    new SqlParameter("@cinvdefine6", SqlDbType.NVarChar,60),
                    new SqlParameter("@cinvdefine7", SqlDbType.NVarChar,120),
                    new SqlParameter("@cinvdefine8", SqlDbType.NVarChar,120),
                    new SqlParameter("@cinvdefine9", SqlDbType.NVarChar,120),
                    new SqlParameter("@cinvdefine10", SqlDbType.NVarChar,120),
                    new SqlParameter("@cinvdefine11", SqlDbType.Int,4),
                    new SqlParameter("@cinvdefine12", SqlDbType.Int,4),
                    new SqlParameter("@cinvdefine13", SqlDbType.Float,8),
                    new SqlParameter("@cinvdefine14", SqlDbType.Float,8),
                    new SqlParameter("@cinvdefine15", SqlDbType.DateTime),
                    new SqlParameter("@cinvdefine16", SqlDbType.DateTime),
                    new SqlParameter("@iid", SqlDbType.Int,4),
                    new SqlParameter("@cfree1", SqlDbType.NVarChar,20),
                    new SqlParameter("@cfree2", SqlDbType.NVarChar,20),
                    new SqlParameter("@cfree3", SqlDbType.NVarChar,20),
                    new SqlParameter("@cfree4", SqlDbType.NVarChar,20),
                    new SqlParameter("@cfree5", SqlDbType.NVarChar,20),
                    new SqlParameter("@cfree6", SqlDbType.NVarChar,20),
                    new SqlParameter("@cfree7", SqlDbType.NVarChar,20),
                    new SqlParameter("@cfree8", SqlDbType.NVarChar,20),
                    new SqlParameter("@cfree9", SqlDbType.NVarChar,20),
                    new SqlParameter("@cfree10", SqlDbType.NVarChar,20),
                    new SqlParameter("@cbatch", SqlDbType.NVarChar,60),
                    new SqlParameter("@iinvexchrate", SqlDbType.Decimal,17),
                    new SqlParameter("@inum", SqlDbType.Decimal,17),
                    new SqlParameter("@iquantity", SqlDbType.Decimal,17),
                    new SqlParameter("@iunitcost", SqlDbType.Decimal,17),
                    new SqlParameter("@iprice", SqlDbType.Money,8),
                    new SqlParameter("@cbarcode", SqlDbType.NVarChar,200),
                    new SqlParameter("@ipunitcost", SqlDbType.Decimal,17),
                    new SqlParameter("@ipprice", SqlDbType.Money,8),
                    new SqlParameter("@dvdate", SqlDbType.DateTime),
                    new SqlParameter("@cobjcode", SqlDbType.NVarChar,12),
                    new SqlParameter("@isoutquantity", SqlDbType.Decimal,17),
                    new SqlParameter("@isoutnum", SqlDbType.Decimal,17),
                    new SqlParameter("@inquantity", SqlDbType.Decimal,17),
                    new SqlParameter("@innum", SqlDbType.Decimal,17),
                    new SqlParameter("@cassunit", SqlDbType.NVarChar,35),
                    new SqlParameter("@dmadedate", SqlDbType.DateTime),
                    new SqlParameter("@ifquantity", SqlDbType.Decimal,17),
                    new SqlParameter("@ifnum", SqlDbType.Decimal,17),
                    new SqlParameter("@cvouchcode", SqlDbType.BigInt,8),
                    new SqlParameter("@cdefine22", SqlDbType.NVarChar,60),
                    new SqlParameter("@cdefine23", SqlDbType.NVarChar,60),
                    new SqlParameter("@cdefine24", SqlDbType.NVarChar,60),
                    new SqlParameter("@cdefine25", SqlDbType.NVarChar,60),
                    new SqlParameter("@cdefine26", SqlDbType.Float,8),
                    new SqlParameter("@cdefine27", SqlDbType.Float,8),
                    new SqlParameter("@cdefine28", SqlDbType.NVarChar,120),
                    new SqlParameter("@cdefine29", SqlDbType.NVarChar,120),
                    new SqlParameter("@cdefine30", SqlDbType.NVarChar,120),
                    new SqlParameter("@cdefine31", SqlDbType.NVarChar,120),
                    new SqlParameter("@cdefine32", SqlDbType.NVarChar,120),
                    new SqlParameter("@cdefine33", SqlDbType.NVarChar,120),
                    new SqlParameter("@cdefine34", SqlDbType.Int,4),
                    new SqlParameter("@cdefine35", SqlDbType.Int,4),
                    new SqlParameter("@cdefine36", SqlDbType.DateTime),
                    new SqlParameter("@cdefine37", SqlDbType.DateTime),
                    new SqlParameter("@impoids", SqlDbType.BigInt,8),
                    new SqlParameter("@icheckids", SqlDbType.BigInt,8),
                    new SqlParameter("@citemcode", SqlDbType.NVarChar,60),
                    new SqlParameter("@citem_class", SqlDbType.NVarChar,10),
                    new SqlParameter("@cname", SqlDbType.NVarChar,255),
                    new SqlParameter("@citemcname", SqlDbType.NVarChar,20),
                    new SqlParameter("@cbvencode", SqlDbType.NVarChar,20),
                    new SqlParameter("@cvenname", SqlDbType.NVarChar,98),
                    new SqlParameter("@imassdate", SqlDbType.Int,4),
                    new SqlParameter("@cinvouchcode", SqlDbType.NVarChar,30),
                    new SqlParameter("@imaterialfee", SqlDbType.Money,8),
                    new SqlParameter("@iomomid", SqlDbType.BigInt,8),
                    new SqlParameter("@iomodid", SqlDbType.Int,4),
                    new SqlParameter("@comcode", SqlDbType.NVarChar,30),
                    new SqlParameter("@cmassunit", SqlDbType.NVarChar,1),
                    new SqlParameter("@cposname", SqlDbType.NVarChar,30),
                    new SqlParameter("@isquantity", SqlDbType.Decimal,17),
                    new SqlParameter("@ismaterialfee", SqlDbType.Money,8),
                    new SqlParameter("@dmsdate", SqlDbType.DateTime),
                    new SqlParameter("@cmocode", SqlDbType.NVarChar,30),
                    new SqlParameter("@imoseq", SqlDbType.Int,4),
                    new SqlParameter("@cmolotcode", SqlDbType.NVarChar,60),
                    new SqlParameter("@iopseq", SqlDbType.NVarChar,10),
                    new SqlParameter("@copdesc", SqlDbType.NVarChar,60),
                    new SqlParameter("@cmworkcentercode", SqlDbType.NVarChar,8),
                    new SqlParameter("@cmworkcenter", SqlDbType.NVarChar,60),
                    new SqlParameter("@invcode", SqlDbType.NVarChar,60),
                    new SqlParameter("@invname", SqlDbType.NVarChar,255),
                    new SqlParameter("@invstd", SqlDbType.NVarChar,255),
                    new SqlParameter("@corufts", SqlDbType.NVarChar,50),
                    new SqlParameter("@isodid", SqlDbType.NVarChar,40),
                    new SqlParameter("@isotype", SqlDbType.TinyInt,1),
                    new SqlParameter("@csocode", SqlDbType.NVarChar,40),
                    new SqlParameter("@isoseq", SqlDbType.Int,4),
                    new SqlParameter("@cdemandmemo", SqlDbType.NVarChar,255),
                    new SqlParameter("@iordertype", SqlDbType.TinyInt,1),
                    new SqlParameter("@iorderdid", SqlDbType.Int,4),
                    new SqlParameter("@iordercode", SqlDbType.NVarChar,30),
                    new SqlParameter("@iorderseq", SqlDbType.Int,4),
                    new SqlParameter("@cbaccounter", SqlDbType.NVarChar,30),
                    new SqlParameter("@bcosting", SqlDbType.Bit,1),
                    new SqlParameter("@dbkeepdate", SqlDbType.DateTime),
                    new SqlParameter("@cvmivencode", SqlDbType.NVarChar,20),
                    new SqlParameter("@cvmivenname", SqlDbType.NVarChar,60),
                    new SqlParameter("@bvmiused", SqlDbType.Bit,1),
                    new SqlParameter("@ivmisettlequantity", SqlDbType.Decimal,17),
                    new SqlParameter("@ivmisettlenum", SqlDbType.Decimal,17),
                    new SqlParameter("@imaids", SqlDbType.BigInt,8),
                    new SqlParameter("@iinvsncount", SqlDbType.Int,4),
                    new SqlParameter("@iuninvsncount", SqlDbType.Decimal,17),
                    new SqlParameter("@cwhpersoncode", SqlDbType.NVarChar,20),
                    new SqlParameter("@cwhpersonname", SqlDbType.NVarChar,50),
                    new SqlParameter("@crejectcode", SqlDbType.NVarChar,30),
                    new SqlParameter("@iexpiratdatecalcu", SqlDbType.SmallInt,2),
                    new SqlParameter("@cexpirationdate", SqlDbType.VarChar,10),
                    new SqlParameter("@dexpirationdate", SqlDbType.DateTime),
                    new SqlParameter("@cciqbookcode", SqlDbType.NVarChar,20),
                    new SqlParameter("@ibondedsumqty", SqlDbType.Decimal,17),
                    new SqlParameter("@productinids", SqlDbType.Int,4),
                    new SqlParameter("@cbatchproperty1", SqlDbType.Decimal,17),
                    new SqlParameter("@cbatchproperty2", SqlDbType.Decimal,17),
                    new SqlParameter("@cbatchproperty3", SqlDbType.Decimal,17),
                    new SqlParameter("@cbatchproperty4", SqlDbType.Decimal,17),
                    new SqlParameter("@cbatchproperty5", SqlDbType.Decimal,17),
                    new SqlParameter("@cbatchproperty6", SqlDbType.NVarChar,120),
                    new SqlParameter("@cbatchproperty7", SqlDbType.NVarChar,120),
                    new SqlParameter("@cbatchproperty8", SqlDbType.NVarChar,120),
                    new SqlParameter("@cbatchproperty9", SqlDbType.NVarChar,120),
                    new SqlParameter("@cbatchproperty10", SqlDbType.DateTime),
                    new SqlParameter("@irsrowno", SqlDbType.Int,4),
                    new SqlParameter("@cbmemo", SqlDbType.NVarChar,255),
                    new SqlParameter("@cbinvsn", SqlDbType.NVarChar,4000),
                    new SqlParameter("@applydid", SqlDbType.Int,4),
                    new SqlParameter("@applycode", SqlDbType.NVarChar,30),
                    new SqlParameter("@irowno", SqlDbType.Int,4),
                    new SqlParameter("@strowguid", SqlDbType.UniqueIdentifier,16),
                    new SqlParameter("@vmiveniid", SqlDbType.Int,4),
                    new SqlParameter("@cservicecode", SqlDbType.NVarChar,30),
                    new SqlParameter("@bveniid", SqlDbType.Int,4),
                    new SqlParameter("@cinvouchtype", SqlDbType.NVarChar,2),
                    new SqlParameter("@coutvouchid", SqlDbType.BigInt,8),
                    new SqlParameter("@coutvouchtype", SqlDbType.NVarChar,2),
                    new SqlParameter("@isredoutquantity", SqlDbType.Decimal,17),
                    new SqlParameter("@isredoutnum", SqlDbType.Decimal,17),
                    new SqlParameter("@itrids", SqlDbType.BigInt,8),
                    new SqlParameter("@ipesodid", SqlDbType.NVarChar,40),
                    new SqlParameter("@ipesotype", SqlDbType.TinyInt,1),
                    new SqlParameter("@cpesocode", SqlDbType.NVarChar,40),
                    new SqlParameter("@ipesoseq", SqlDbType.Int,4),
                    new SqlParameter("@bsupersede", SqlDbType.Int,4),
                    new SqlParameter("@isupersedeqty", SqlDbType.Decimal,17),
                    new SqlParameter("@isupersedempoids", SqlDbType.Int,4),
                    new SqlParameter("@imoallocatesubid", SqlDbType.UniqueIdentifier,16),
                    new SqlParameter("@cinvouchercode", SqlDbType.NVarChar,40),
                    new SqlParameter("@cinvoucherlineid", SqlDbType.Int,4),
                    new SqlParameter("@cinvouchertype", SqlDbType.NVarChar,20),
                    new SqlParameter("@cbsysbarcode", SqlDbType.NVarChar,80),
                    new SqlParameter("@csourcemocode", SqlDbType.NVarChar,30),
                    new SqlParameter("@isourcemodetailsid", SqlDbType.Int,4),
                    new SqlParameter("@cplanlotcode", SqlDbType.NVarChar,80),
                    new SqlParameter("@bcanreplace", SqlDbType.Int,4),
                    new SqlParameter("@iposflag", SqlDbType.SmallInt,2),
                    new SqlParameter("@boutmaterials", SqlDbType.SmallInt,2),
                    new SqlParameter("@iavaquantity", SqlDbType.Decimal,17),
                    new SqlParameter("@iavanum", SqlDbType.Decimal,17),
                    new SqlParameter("@ipresent", SqlDbType.Decimal,17),
                    new SqlParameter("@ipresentnum", SqlDbType.Decimal,17)};
            parameters[0].Value = autoid;
            parameters[1].Value = id;
            parameters[2].Value = cinvcode;
            parameters[3].Value = cinvaddcode;
            parameters[4].Value = cinvname;
            parameters[5].Value = cinvstd;
            parameters[6].Value = cinvccode;
            parameters[7].Value = cinvm_unit;
            parameters[8].Value = cinva_unit;
            parameters[9].Value = creplaceitem;
            parameters[10].Value = cposition;
            parameters[11].Value = cinvdefine1;
            parameters[12].Value = cinvdefine2;
            parameters[13].Value = cinvdefine3;
            parameters[14].Value = cinvdefine4;
            parameters[15].Value = cinvdefine5;
            parameters[16].Value = cinvdefine6;
            parameters[17].Value = cinvdefine7;
            parameters[18].Value = cinvdefine8;
            parameters[19].Value = cinvdefine9;
            parameters[20].Value = cinvdefine10;
            parameters[21].Value = cinvdefine11;
            parameters[22].Value = cinvdefine12;
            parameters[23].Value = cinvdefine13;
            parameters[24].Value = cinvdefine14;
            parameters[25].Value = cinvdefine15;
            parameters[26].Value = cinvdefine16;
            parameters[27].Value = iid;
            parameters[28].Value = cfree1;
            parameters[29].Value = cfree2;
            parameters[30].Value = cfree3;
            parameters[31].Value = cfree4;
            parameters[32].Value = cfree5;
            parameters[33].Value = cfree6;
            parameters[34].Value = cfree7;
            parameters[35].Value = cfree8;
            parameters[36].Value = cfree9;
            parameters[37].Value = cfree10;
            parameters[38].Value = cbatch;
            parameters[39].Value = iinvexchrate;
            parameters[40].Value = inum;
            parameters[41].Value = iquantity;
            parameters[42].Value = iunitcost;
            parameters[43].Value = iprice;
            parameters[44].Value = cbarcode;
            parameters[45].Value = ipunitcost;
            parameters[46].Value = ipprice;
            parameters[47].Value = dvdate;
            parameters[48].Value = cobjcode;
            parameters[49].Value = isoutquantity;
            parameters[50].Value = isoutnum;
            parameters[51].Value = inquantity;
            parameters[52].Value = innum;
            parameters[53].Value = cassunit;
            parameters[54].Value = dmadedate;
            parameters[55].Value = ifquantity;
            parameters[56].Value = ifnum;
            parameters[57].Value = cvouchcode;
            parameters[58].Value = cdefine22;
            parameters[59].Value = cdefine23;
            parameters[60].Value = cdefine24;
            parameters[61].Value = cdefine25;
            parameters[62].Value = cdefine26;
            parameters[63].Value = cdefine27;
            parameters[64].Value = cdefine28;
            parameters[65].Value = cdefine29;
            parameters[66].Value = cdefine30;
            parameters[67].Value = cdefine31;
            parameters[68].Value = cdefine32;
            parameters[69].Value = cdefine33;
            parameters[70].Value = cdefine34;
            parameters[71].Value = cdefine35;
            parameters[72].Value = cdefine36;
            parameters[73].Value = cdefine37;
            parameters[74].Value = impoids;
            parameters[75].Value = icheckids;
            parameters[76].Value = citemcode;
            parameters[77].Value = citem_class;
            parameters[78].Value = cname;
            parameters[79].Value = citemcname;
            parameters[80].Value = cbvencode;
            parameters[81].Value = cvenname;
            parameters[82].Value = imassdate;
            parameters[83].Value = cinvouchcode;
            parameters[84].Value = imaterialfee;
            parameters[85].Value = iomomid;
            parameters[86].Value = iomodid;
            parameters[87].Value = comcode;
            parameters[88].Value = cmassunit;
            parameters[89].Value = cposname;
            parameters[90].Value = isquantity;
            parameters[91].Value = ismaterialfee;
            parameters[92].Value = dmsdate;
            parameters[93].Value = cmocode;
            parameters[94].Value = imoseq;
            parameters[95].Value = cmolotcode;
            parameters[96].Value = iopseq;
            parameters[97].Value = copdesc;
            parameters[98].Value = cmworkcentercode;
            parameters[99].Value = cmworkcenter;
            parameters[100].Value = invcode;
            parameters[101].Value = invname;
            parameters[102].Value = invstd;
            parameters[103].Value = corufts;
            parameters[104].Value = isodid;
            parameters[105].Value = isotype;
            parameters[106].Value = csocode;
            parameters[107].Value = isoseq;
            parameters[108].Value = cdemandmemo;
            parameters[109].Value = iordertype;
            parameters[110].Value = iorderdid;
            parameters[111].Value = iordercode;
            parameters[112].Value = iorderseq;
            parameters[113].Value = cbaccounter;
            parameters[114].Value = bcosting;
            parameters[115].Value = dbkeepdate;
            parameters[116].Value = cvmivencode;
            parameters[117].Value = cvmivenname;
            parameters[118].Value = bvmiused;
            parameters[119].Value = ivmisettlequantity;
            parameters[120].Value = ivmisettlenum;
            parameters[121].Value = imaids;
            parameters[122].Value = iinvsncount;
            parameters[123].Value = iuninvsncount;
            parameters[124].Value = cwhpersoncode;
            parameters[125].Value = cwhpersonname;
            parameters[126].Value = crejectcode;
            parameters[127].Value = iexpiratdatecalcu;
            parameters[128].Value = cexpirationdate;
            parameters[129].Value = dexpirationdate;
            parameters[130].Value = cciqbookcode;
            parameters[131].Value = ibondedsumqty;
            parameters[132].Value = productinids;
            parameters[133].Value = cbatchproperty1;
            parameters[134].Value = cbatchproperty2;
            parameters[135].Value = cbatchproperty3;
            parameters[136].Value = cbatchproperty4;
            parameters[137].Value = cbatchproperty5;
            parameters[138].Value = cbatchproperty6;
            parameters[139].Value = cbatchproperty7;
            parameters[140].Value = cbatchproperty8;
            parameters[141].Value = cbatchproperty9;
            parameters[142].Value = cbatchproperty10;
            parameters[143].Value = irsrowno;
            parameters[144].Value = cbmemo;
            parameters[145].Value = cbinvsn;
            parameters[146].Value = applydid;
            parameters[147].Value = applycode;
            parameters[148].Value = irowno;
            parameters[149].Value = strowguid;
            parameters[150].Value = vmiveniid;
            parameters[151].Value = cservicecode;
            parameters[152].Value = bveniid;
            parameters[153].Value = cinvouchtype;
            parameters[154].Value = coutvouchid;
            parameters[155].Value = coutvouchtype;
            parameters[156].Value = isredoutquantity;
            parameters[157].Value = isredoutnum;
            parameters[158].Value = itrids;
            parameters[159].Value = ipesodid;
            parameters[160].Value = ipesotype;
            parameters[161].Value = cpesocode;
            parameters[162].Value = ipesoseq;
            parameters[163].Value = bsupersede;
            parameters[164].Value = isupersedeqty;
            parameters[165].Value = isupersedempoids;
            parameters[166].Value = imoallocatesubid;
            parameters[167].Value = cinvouchercode;
            parameters[168].Value = cinvoucherlineid;
            parameters[169].Value = cinvouchertype;
            parameters[170].Value = cbsysbarcode;
            parameters[171].Value = csourcemocode;
            parameters[172].Value = isourcemodetailsid;
            parameters[173].Value = cplanlotcode;
            parameters[174].Value = bcanreplace;
            parameters[175].Value = iposflag;
            parameters[176].Value = boutmaterials;
            parameters[177].Value = iavaquantity;
            parameters[178].Value = iavanum;
            parameters[179].Value = ipresent;
            parameters[180].Value = ipresentnum;

          return  DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
        }
        #endregion  Method
    }
}